HOW TO INSTALL MYSQL 5.6 ON CENTOS 6.3_REDHAT EL6_FEDORA
HOW TO INSTALL MYSQL 5.6 ON CENTOS 6.3_REDHAT EL6_FEDORA
How to Install MySQL
5.6 on CentOS 6.3/RedHat EL6/Fedora\
First head over
here and
download MySQL 5.6.14 rpm’s under Oracle & Redhat Linux 6 section of
rpm’s.
You want to download these rpm’s to your CentOS 6 server [As we will
install 64bit version on MySQL 5.6] :
- Red Hat/Oracle Enterprise Linux ver. 6 (x86, 64-bit), RPM Package –
MySQL Server : MySQL-server-5.6.14-1.el6.x86_64.rpm - Red Hat/Oracle Enterprise Linux ver. 6 (x86, 64-bit), RPM Package –
Shared components : MySQL-shared-5.6.14-1.el6.x86_64.rpm - Red Hat/Oracle Enterprise Linux ver. 6 (x86, 64-bit), RPM Package –
Client Utilities : MySQL-client-5.6.14-1.el6.x86_64.rpm
To download on command line [Make sure that you have wget utility
installed, if not install it :
yum install wget
Now download the rpm’s with wget utility:
wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-shared-5.6.14-1.el6.x86_64.rpm/from/http://cdn.mysql.com/
wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-client-5.6.14-1.el6.x86_64.rpm/from/http://cdn.mysql.com/
wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-server-5.6.14-1.el6.x86_64.rpm/from/http://cdn.mysql.com/
Now start installing rpms onto your server:
Make sure that Perl is installed on your server before you install
MySQL, if not MySQL server rpm will complain that it cannot be
installed. So its kind of pre-requisite.
To Install perl run :
yum install perl
Install MySQL 5.6 rpms now :
Start with shared libraries first and then work towards installing
server and client utilities at the very end.
rpm -ivh MySQL-shared-5.6.14-1.el6.x86_64.rpm
rpm -ivh MySQL-server-5.6.14-1.el6.x86_64.rpm
rpm -ivh MySQL-client-5.6.14-1.el6.x86_64.rpm
If you have conflicts with existing libs(install of
MySQL-server-5.6.10-1.el6.x86_64 conflicts with file from package
mysql-libs-5.1.66-2.el6_3.x86_64), please download shared-compact
package and do the following (Once complete, please re-install as stated
above) :
wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-shared-compat-5.6.14-1.el6.x86_64.rpm/from/http://cdn.mysql.com/
rpm -UvhMySQL-shared-compat-5.6.10-1.el6.x86_64.rpm
On a successful install you should be seeing the log below:
MySQL
Server Installation log:
Preparing…
###########################################
[100%]
1:MySQL-server
###########################################
[100%]
2013-02-08 14:59:19 0 [Warning] TIMESTAMP with implicit DEFAULT value
is deprecated. Please use –explicit_defaults_for_timestamp server
option (see documentation for more details).
2013-02-08 14:59:19 2959 [Note] InnoDB: The InnoDB memory heap is
disabled
2013-02-08 14:59:19 2959 [Note] InnoDB: Mutexes and rw_locks use GCC
atomic builtins
2013-02-08 14:59:19 2959 [Note] InnoDB: ………
2013-02-08 14:59:19 2959 [Note] InnoDB: ………
A RANDOM PASSWORD HAS BEEN SET FOR THE MySQL root USER ! You will find
that password in ‘/root/.mysql_secret’.
You must change that password on your first connect, no other statement
but ‘SET PASSWORD’ will be accepted. See the manual for the semantics of
the ‘password expired’ flag.
Also, the account for the anonymous user has been removed.
In addition, you can run:
/usr/bin/mysql_secure_installation
which will also give you the option of removing the test database. This
is strongly recommended for production servers.
See the manual for more instructions.
Please report any problems with the /usr/bin/mysqlbug script!
The latest information about MySQL is available on the web at
Support MySQL by buying support/licenses at http://shop.mysql.com
WARNING: Found existing config file /usr/my.cnf on the system. Because
this file might be in use, it was not replaced, but was used in
bootstrap (unless you used –defaults-file) and when you later start the
server. The new default config file was created as /usr/my-new.cnf,
please compare it with your file and take the changes you need.
Its all done, lets set some passwords, create user and grant access to
outside clients for accessing the database:
In MySQL 5.6 root has a default password assigned and its located
at /root/.mysql_secret file as mention in MySQL server Installation
log.
cat that file :
cat /root/.mysql_secret
to get the password that has been set for MySQL default root user
Now lets login to the database server for the first time and set
password. That’s the only first SQL command that works before you can
proceed any further. To do that we need to start our newly installed
database server.
service mysql start
Now login into database server using MySQL client utility and change
password. To login into database server simply run command below and
provide with the password that installation generated for you in
/root/.mysql_secret file.
mysql -uroot -p
Once you logged in, you have to change your root users default password.
You cannot run any others commands.
To change MySQL 5.6 database server root password simply run this
command :
SET PASSWORD FOR 'root' 'localhost'= PASSWORD('opensourcedbms');
Also there are other root users in MySQL if you are familiar with its
users table [root 127.0.0.1 ; root ::1, root hostname], once you
login with superuser you can update all of them later. Also once all
this is done you can remove /root/.mysql_secret file.
Now that you have set root user password, create a super user to access
database server from outside server. Its generally not a good practice
to grant root user access to outside world.
CREATE USER 'superadmin' '%' IDENTIFIED BY 'opensourcedbmsadmin';
GRANT ALL ON *.* TO 'superadmin' '%' WITH GRANT OPTION;
Now you can exit out of mysql command line client
[Type \q or quit to exit] and we can use this newly created
user to access this database server from outside world. Before you can
do that, make sure that your server firewall rules are updated for
granting this server to respond at port 3306 for outside world. First
get out of the mysql command line client and to add a new firewall rule
to your CentOS database server firewall rules and to do that edit
vi /etc/sysconfig/iptables
file and add the following line:
-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306-j ACCEPT
Save and exit out of the file and restart iptables for the new rule to
take effect. To restart iptables, simply run the following command :
service iptables restart
Last but not least make sure that this new MySQL server is enabled to
auto start when server restarts.
chkconfig mysql --level 2345 on
Now you are ready to connect to this database server from any host in
your network. Simply open a database client [MySQL Workbench / Navicat
/ SQLYog are few clients that you can use to access it from GUI side of
things] that you installed and provide the new super user/password that
you created and the host-name of this server and there you will be in
your new database server.
If you are running this server in a virtual box environment, make sure
that you do port forwarding (NAT Only) to pass through 3306 database
port to guest VM which can be done by going to settings of your VM >
Network > Advanced > Port forwarding. This is more specific to
Oracle Virtual Box.
